Index Scan
Short Description
The Index Scan operator retrieves all rows from a nonclustered index.
Detailed Description​
The Index Scan operator retrieves all rows from a non-clustered index. If a WHERE clause is specified, only matching rows will be returned.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.